Validating if psid is not null

Other numbers

SELECT COUNT("realId") FROM c

1. Bot A from cosmos

a. Getting PSID from document columns

b. Getting PSID from realId

<--- End of (b) --->

c. Time beginning

<--- End of (c) --->

d. Fixing bot A or B, is column = 0 A, =1 B

<--- End of (d) --->

e. Time finished or timestamp state

<--- End of (e) --->

f. Time finished or timestamp state

<--- End of (f) --->

DF Bot B from cosmos

1. Bot B from cosmos

a. Getting PSID from document columns

b. Getting PSID from realId

<--- End of (b) --->

c. Time beginning

<--- End of (c) --->

d. Fixing bot A or B, is column = 0 A, =1 B

e. Time finished or timestamp state

<--- End of (e) --->

f. Time finished or timestamp state

<--- End of (f) --->

1631178000 09/09 9am start of trials

Merging Conversations and Responses

Cleaning final data

  1. Deleting conversations without psid
  2. Deleting test psid
  3. Deleting for timeframe
  4. Comparing bots from state and from db

Engagement